Q Financial Analysis of the Chosen Company Stock ticker symbol, exchange where traded _________ Address of company headquarters _________ Company phone number __________ Your team and student names PART 1, COMPANY OVERVIEW: a. Brief description of the company (one paragraph, briefly summarizing the company’s business) b. Company history (origin, major developments) c. Organization (describe how the company is structured) d. Main products and services (describe what the company sells; how it makes money) e. Geographic area of operations (describe where the company sells its products) f. Recent developments (list recent major news stories, if any) PART 2, FINANCIAL OVERVIEW: Use the most recent 5 years data a. Sales and Income Record: ------------- Fiscal Years ------------- 2017 2018 2019 2020 2021 Sales ____ ____ ____ ____ ____ Percent change in sales each year ____ ____ ____ ____ Net Income ____ ____ ____ ____ ____ Percent change in net income each year ____ ____ ____ ____ GRAPH OF SALES & NET INCOME, FY 2017 2021 | | | (Plot Sales and Net Income for the | last five fiscal years on the graph) | | (Recommend you prepare the graph in Excel, | then copy and paste it into the report) | | | | | | | |-- 2017 2018 2019 2020 2021 COMMENTS: Comment on the trends you see in your numbers and on the graph. Be sure to include comments! The numbers and the chart are meaningless by themselves. Comment on what you see. b. Expense Distribution: FY - most current year Major Expenses: ________ (List the major expense categories ________ from the latest income statement) ________ PIE CHART OF EXPENSES, FY 2021 Note – Do not “explode” the pie slices COMMENTS: Comment on the company’s expense distribution. c. Assets Distribution: Year-end FY 2021 Assets: Cash ________ Accounts receivable ________ Inventory ________ Fixed Assets ________ Other Assets ________ PIE CHART OF ASSETS, Year-end FY 2021 COMMENTS: Comment on the company’s asset distribution. c. Capital Structure: Year-end FY 2021 Capital Structure: Current Liabilities ________ Long-term & Other Liabilities ________ Preferred Stock (if any) ________ Common Equity ________ CAPITAL STRUCTURE PIE CHART, Year-end FY 2021 COMMENTS: Comment on the company’s capital structure. PART 3, RATIO ANALYSIS: Use the most recent 2 years (1) LIQUIDITY: FY 2020 FY 2021 Current Ratio: Chosen Co. ____ ____ Competitor ____ ____ Quick Ratio: Chosen Co. ____ ____ Competitor ____ ____ Comments On the Company’s Liquidity: Be sure to include comments! The numbers are meaningless by themselves. Comment on what you see. What story do the numbers tell? (2) ASSET MANAGEMENT FY 2020 FY 2021 Total Asset Turnover: Chosen Co. ____ ____ Competitor ____ ____ Average Collection Period: Chosen Co. ____ ____ Competitor ____ ____ Comments On the Company’s Asset Management: (3) DEBT MANAGEMENT: FY 2020 FY 2021 Total Debt to Total Assets: Chosen Co. ____ ____ Competitor ____ ____ Times Interest Earned: Chosen Co. ____ ____ Competitor ____ ____ Comments On the Company’s Debt Management: (4) PROFITABILITY: FY 2020 FY 2021 Net profit Margin: Chosen Co. ____ ____ Competitor ____ ____ Return on Assets: Chosen Co. ____ ____ Competitor ____ ____ Return on Equity: Chosen Co. ____ ____ Competitor ____ ____ Modified Du Pont Equation, FY 2021: Chosen Co. Competitor Net Profit Margin ____ ____ Total Asset Turnover ____ ____ Equity Multiplier ____ ____ Comments On the Company’s Profitability: (5) MARKET VALUE RATIOS: FY 2020 FY 2021 PE Ratio: Chosen Co. ____ ____ Competitor ____ ____ Market to Book Ratio: Chosen Co. ____ ____ Competitor ____ ____ Comments On the Company’s Market Value Ratios: PART 4, CONCLUSIONS AND RECOMMENDATIONS Summarize your analysis. Review your comments in the financial analysis section and provide your assessment of the overall status of the firm. Include any recommendations you think are appropriate. List any other recommendations you have for the firm in view of your analysis. References * End of report Outline *